AA - Site Basic --------------- This transactions contains the primary (basic) information defining a site. This is primarily geophysical information. Where possible, the provided latitude and longitude are used to look up at the Census Bureau geodatabase and populate with the values we get from there. If data is provided in the transaction, it will override what AQS gets from the Census Bureau. Examples: .. code-block:: text :caption: AA transaction in default mode AA|I|06|001|0009|37.743065|-122.169935||||103|WGS84||6|11|PACIFIC|0086|9925 International Blvd|53000|7360|030|RESIDENTIAL|URBAN AND CENTER CITY|20071101||94603|9|1000||409300|||Oakland||||||||||014|NAVD88|1 .. code-block:: text :caption: AA transaction in Tribal mode AA|I|TT|614|7004|33.117556|-111.885814||||027|WGS84|24000|12|359|MOUNTAIN|614|CASA BLANCA/PRESCHOOL ROAD, BAPCHULE, AZ 85221|||015|RESIDENTIAL|RURAL|20020701||85247|7|2067||941100|||Casa Blanca Air Monitoring Site||||||||||014|MEAN SEA-LEVEL|3 Format ^^^^^^ .. list-table:: AA - Site Basic transaction format :widths: 1 5 15 4 3 1 :header-rows: 1 * - Seq. - Name - Description - Formatting Rules - Required - Key * - 1 - `Transaction Type `_ - Basic Site Info transaction identifier - Must = AA - Always - * - 2 - `Action Indicator `_ - Indicator for Insert, Update, or Delete action. - Must = I, U, or D - Always - * - 3 - `State Code / Tribal Indicator `_ - The FIPS state code of the monitor, or "TT" to indicate that the next field on the transaction is a Tribal code. - Must exist in STATES Reference Table or be 'TT' for Tribal Site - Always - Y * - 4 - `County Code / Tribal Code `_ - The FIPS County Code of the site. If the previous field on the transaction contains "TT", then the Tribal Code of the site. - Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table - Always - Y * - 5 - `Site Number `_ - Four digit number to uniquely identify site in county and/or tribe. - Must exist in SITES table with {State Code, county Code} or Tribal Code - Always - Y * - 6 - `Latitude `_ - The angular distance north or south of the equator measured in decimal degrees. North is positive. - Decimal, must be in county specified above - Always - * - 7 - `Longitude `_ - The angular distance east or west of the prime meridian measured in decimal degrees. East is positive. - Decimal, must be in county specified above - Always - * - 8 - `UTM Zone `_ - Ignored by AQS. The zone of the universal transverse Mercator (UTM) geographic system. - Integer - 2 digit. - Deprecated, Lat/Lon required - * - 9 - `UTM Easting `_ - Ignored by AQS. The easting UTM coordinate, expressed in meters. - Decimal. - Deprecated, Lat/Lon required - * - 10 - `UTM Northing `_ - Ignored by AQS. The northing UTM coordinate expressed in meters. - Decimal. - Deprecated, Lat/Lon required - * - 11 - `Lat Lon Collection Method `_ - Method used to determine the latitude/longitude or UTM coordinates. - Must exist in LDP COLLECTION METHODS reference table. - Insert - * - 12 - `Lat Lon Datum `_ - The geographic datum used as a baiss for lat/lon or UTM coordinates. - Must equal 'WGS84' - Insert - * - 13 - `Lat Lon Source Scale `_ - Identifies the ratio of a map distance to an actual distance. - Decimal. - If map is source - * - 14 - `Lat Lon Accuracy `_ - Description of the accuracy of the site coordinates, in meters. - Decimal. - Insert - * - 15 - `Elevation `_ - The elevation of the ground at the site, in meters above mean sea level (MSL). - Decimal. - Insert - * - 16 - `Time Zone `_ - The name of the region representing an offset from Greenwich mean time (GMT). - Must exist in TIME ZONES reference table. - Insert - * - 17 - `Agency Code `_ - Identifies the agency responsible for the operation of the monitoring site. - Must exist in AGENCIES reference table. - Insert - * - 18 - `Site Address `_ - Specifies the building/street location of the monitoring site. - Text. - Insert - * - 19 - `City Code `_ - The city within whose incorporated boundaries the monitoring site is located. - Must exist in CITIES reference table. - No - * - 20 - `Urban Area Code `_ - The urbanized area (census defined) within which the monitoring site is located. - Must exist in URBANIZED AREAS reference table. - No - * - 21 - `AQCR Code `_ - The Air Quality Control Region where the site is located. - Must exist in AQCRs reference table. - No - * - 22 - `Land Use Type `_ - Categorization of the prevalent land use within 1/4 mile of the monitoring site. - Must exist in LAND USE TYPES reference table. - Insert - * - 23 - `Location Setting `_ - A description of the environmental setting within which the site is located. - Must exist in LOCATION SETTINGS reference table. - Insert - * - 24 - `Site Established Date `_ - The date on which an air monitoring site began collecting air quality data. - YYYYMMDD. - Insert - * - 25 - `Site Terminated Date `_ - The date on which a monitoring site ceased to operate. - YYYYMMDD. - No - * - 26 - `Zip Code `_ - The US Postal Service code of the site. - Must exist in ZIP CODES reference table. - No - * - 27 - `Congressional District `_ - The Congressional district within which the site is located. - Must exist in CONGRESSIONAL DISTRICTS reference table. - No - * - 28 - `Census Block `_ - The US Census Bureau block within which the site is located. - Must exist in BLOCKS reference table. - No - * - 29 - `Census Block Group `_ - This field is ignored by AQS. - N/A - No - * - 30 - `Census Tract `_ - The US Census Bureau tract within which the site is located. - Must exist in BLOCKS reference table. - No - * - 31 - `Class 1 Area Code `_ - The Class One Area within which the site is located. - Must exist in CLASS ONE AREAS reference table. - No - * - 32 - `Local Region Code `_ - The state-specific geographic/administrative area within which the site is located. - Must exist in LOCAL REGIONS reference table. - No - * - 33 - `Local Site Name `_ - The locally defined name of the site. - Text (up to 70 characters). - No - * - 34 - `HQ Evaluation Date `_ - The date on which the most recent headquarters (HQ) evaluation of the site occurred. - YYYYMMDD. - No - * - 35 - `EPA Region Evaluation Date `_ - The date on which the most recent EPA Regional Evaluation of the site for siting criteria occurred. - YYYYMMDD. - No - * - 36 - `Direction from Central Business District to Site `_ - A representation of the true, as opposed to magnetic, direction of the site from the central business district. - Must exist in COMPASS SECTORS reference table. - No - * - 37 - `Distance from Central Business District to Site `_ - The distance, in kilometers, to the site from the center of the downtown central business district of the city in which the site is located. - Decimal. - No - * - 38 - `Meteorological Site Type `_ - The type of meteorological station identified for the monitoring site. Required for PAMS sites. - Must exist in MET SITE TYPES reference table. - Conditional - * - 39 - `Meteorological Site ID `_ - The AQS Site ID where meteorological data is collected, if not collected at this site. - Must exist in AQS SITES table. - If met site type provided - * - 40 - `Distance to Meteorological Site `_ - The distance of the associated meteorological site from the air quality monitoring site, in meters. - Decimal. - If met site type provided - * - 41 - `Direction to Meteorological Site `_ - A representation of the true, as opposed to magnetic, direction of the meteorological site from this site. - Must exist in COMPASS SECTORS reference table. - If met site type provided - * - 42 - `Local Site ID `_ - Identification code used by a State, Tribe or Local agency, if different from the AQS Site ID. - Text. - No - * - 43 - `Elevation Collection Method `_ - The method used to determine the vertical measure. - Must exist in LDP VERTICAL METHODS reference table. - Insert - * - 44 - `Elevation Datum `_ - The geographic datum used as a baiss for vertical coordinates. - Must exist in LDP VERTICAL DATA reference table. - Insert - * - 45 - `Elevation Accuracy `_ - Description of the accuracy of the Vertical Measure, reported in meters. - Decimal. - Insert -